﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MusicOnSpace
{
    public class Songs
    {
        public string songId { get; set; }
        public string songName { get; set; }
        public string songGenre { get; set; }
        public string songArtist { get; set; }
        public string songTime { get; set; }
        public string songRate { get; set; }
        public string songListen { get; set; }
        public string songDownload { get; set; }

        List<Songs> SongsList = new List<Songs>();
        dataProvider dp = new dataProvider();

        public void InsertSongsber(string id, string name, string genre, string singname, string descript)
        {
            string command = "Insert into Songs (aId, aName, aGenre, aCoverUrl, singName, Description) values (" + id + "," + name + "," + genre + "," + singname + "," + descript +")";

            dp.ExeCuteNonQuery(command);
        }

        public void DeleteSongsber(string id)
        {
            string command = "";
            dp.ExeCuteNonQuery(command);
        }

        public void SongsSearch(string name)
        {
            string command = "Select * from Songs where name like 'N" + name + "'";
            dp.ExeCuteNonQuery(command);
        }

        public void GetSongsber()
        {

        }

        public List<Songs> AddSongs()
        {
            //SqlCommand cmd = new SqlCommand ("Insert into Songsber (
            return SongsList;
        }
    }
}